Data Journalism in Arkansas
Jour 4083, Fall 2021
Class Time: KIMP 145, Monday-Wednesday, 3:30 p.m.-4:45 p.m.
Aug. 23 - Dec. 9, 2020

Rob Wells, Ph.D.

@rwells1961

Syllabus - Jour 4083: “CNTL” + click for a New Tab

Course Text: “CNTL” + click for a New Tab

Summary Course Assignments

These assignments topics may shift and evolve as we continue our reporting during the semester. I will provide advance notice of any changes.

1: Data Analysis. Due Sept. 12 Students will gather, analyze and visualize Arkansascovid data and report and write a 400 word story and provide social media with a basic chart.

2: Reporting Memo with Tableau Chart. Due Oct 3
Students gather, analyze and visualize Arkansascovid data and produce a Tableau chart suitable for publication. Data dictionary required. Report and write a 400 word story and provide social media.

3: Interactive Map. Due Oct 24 Students will build interactive maps of Arkansascovid data. Results will be posted on GitHub. Data dictionary required. Basic R used for analysis. Report and write a 400 word story.

4: Interactive Data Visualization. Due Nov 14. Students build multipanel interactive graphics / maps of Arkansascovid data by school district. Basic R used for analysis. Results will be posted on GitHub. Data dictionary required. Report and write a 600 word story.

5: Multimedia Data Story. Due Dec 5. Students will produce a blog post with photos, a short video, a map and an interactive graphic plus a 400 word story. Basic R used for analysis. Results will be posted on GitHub. Data dictionary required.


Monday, Aug. 23: Course Tools, Excel Basics

Agenda:

--Discuss syllabus
--Blackboard site
--Arkansascovid.com
--Excel / Flourish Exercise with Arkansascovid data
--Teams
--Interview a classmate for homework

Discuss Syllabus

https://forms.office.com/r/nrySuungzH

Basic Excel

Click below on the ebook link, See Section "3 Introduction to Data Analysis"

https://bookdown.org/connect/#/apps/f79d74ff-4d33-4bfd-a1aa-de6aaf4e340a/access

Create a Flourish account

https://app.flourish.studio/login

Teams

See Chapter: Teams

https://bookdown.org/connect/#/apps/f79d74ff-4d33-4bfd-a1aa-de6aaf4e340a/access

Homework

Write 200 Word Story Introducing A Classmate To The Rest of Us. Due Tuesday, 11:59 pm, Blackboard.

What questions will you ask? Let’s brainstorm

https://docs.google.com/document/d/10ZlhnxEkJi88spQ_3lyGni8TtF97KcIu1R5nAQonfLk/edit?usp=sharing

Read / View Before Next Class

Sheffo, Catherine. “How to Avoid 10 Common Mistakes in Data Reporting.” American Press Institute (blog), August 9, 2016. https://www.americanpressinstitute.org/publications/data-reporting-common-mistakes/

Chapter 3 Introduction to Data Analysis https://bookdown.org/connect/#/apps/f79d74ff-4d33-4bfd-a1aa-de6aaf4e340a/access

Flourish Tutorial: https://www.youtube.com/watch?v=fKO_jjqgooc&feature=emb_title

Jour 5083 _ Nerd Corner

--Import Arkansascovid.com vaccine data, chart vaccination trends since July 1, 2021
--Post your visualization with Homework

https://raw.githubusercontent.com/Arkansascovid/Main/master/MasterData/vaccine.csv


Wednesday, Aug. 25: Excel, Flourish

Agenda

  Arkansascovid.com
  Excel exercises - sorting
  Intro to Flourish
  Intellectual Property / Data Sharing Releases

Intellectual Property / Data Sharing Releases

UofA Rules of Conduct

https://docs.google.com/document/d/1YkdkRIzIs1WQ3P9KIICvHcppfWvwTyo2bRhGwQPsgVE/edit

License Agreement

https://docs.google.com/document/d/1AahzxDOzTf9Z6PBjBvFBOjnn9_BiM4YldnXW-mHZr9s/edit

Excel Proficiency

Entering data, cursors, formatting, sum, average, median, change, percent change https://raw.githubusercontent.com/Arkansascovid/Main/master/MasterData/vaccine.csv

Skills: Data Dictionary, Part 1 Skills: Organize Your Data. Finder, Storage, File Organization

How to Create a Flourish Chart

  Create a Flourish account    

https://app.flourish.studio/login

See Chapter: Flourish

https://bookdown.org/connect/#/apps/f79d74ff-4d33-4bfd-a1aa-de6aaf4e340a/access

Basic Flourish

Videos to Get Started
Beginning Documents
Flourish Design Tips
Flourish Links

Jour 5083 _ Nerd Corner

  Those of you who don't need a Flourish introduction, please do this
  1) Create a new Flourish project and link to this Sheet

https://raw.githubusercontent.com/Arkansascovid/Main/master/MasterData/vaccine.csv

Read Before Next Class

Sage Research Methods: Choosing the Right Visualization Tools for COVID-19 Data https://methods.sagepub.com/video/srmpromo/UEODnk/choosing-the-right-visualization-tools-for-covid-19-data

Principles of Data Visualization https://wordpressua.uark.edu/datareporting/data-visualization/

Gov. Hutchison’s YouTube Channel. Check the Aug. 19 event https://www.youtube.com/channel/UCLJcNdgp2PMEmiqJEoYzqwQ

Homework due Friday, Aug. 27, 11:59 p.m. –See Blackboard for Excel assignment

–See Blackboard, Data Literacy Test


Monday, Aug. 31: Excel and Flourish

Agenda

Excel
Flourish

Excel

Percentage Change
Average
Tabs
Data Dictionary

https://raw.githubusercontent.com/Arkansascovid/Main/master/MasterData/vaccine.csv

Flourish

Visualization Options
Headline, Footer Formatting
Sourcing
Colors

Homework due Tuesday, Aug 31, 11:59 p.m.
–See Blackboard, Aug 31

Read Before Next Class

Chapter: Introduction to Data Analysis https://bookdown.org/connect/#/apps/f79d74ff-4d33-4bfd-a1aa-de6aaf4e340a/access

View and Read Flourish Tutorials Before Next Class


Wednesday, Sept. 1 - Flourish, Excel

Agenda

Excel
Flourish
Review Introduction to Data Analysis

Introduction to data analysis, including math for journalists

Basics of Data Analysis
Numbers in the Newsroom
Excel Exercise: Transit Data and Calculating a Rate
Review: Mac OSX Basics    

Reminder: Assignment 1: Data Analysis. Due Sept. 12 Students will gather, analyze and visualize Arkansascovid data and report and write a 400 word story and provide social media with a basic chart.

Talk to me about your ideas.

Homework / Reading due Friday, Sept. 3, 11:59 p.m.

See Blackboard.

Chapter: Data Visualization https://bookdown.org/connect/#/apps/f79d74ff-4d33-4bfd-a1aa-de6aaf4e340a/access


Monday, Sept. 6: Data Types, Tableau

Happy Labor Day! No Class


Wednesday, Sept. 8: Data Types, Data Cleaning

Agenda

Sorting
Data Cleaning
Discuss, Work on Data Analysis Assignment.

Data cleaning

Filtering
Reading Data Dictionaries
Data Cleaning Exercises    

Homework: See Blackboard, Sept. 10 Homework

Reminder: Assignment 1: Data Analysis. Due Sept. 12 Talk to me about your ideas.

  • Exercise

Read Before Next Class

Chapter: Data Visualization https://bookdown.org/connect/#/apps/f79d74ff-4d33-4bfd-a1aa-de6aaf4e340a/access


Monday, Sept. 13: Data Visualizatiion

Agenda

Principles of Data Visualization
Tableau

Assignment 1: Data Analysis. Due Sept. 12

Students will gather, analyze and visualize Arkansascovid data and report and write a 400 word story and provide social media with a basic chart.

Data Visualization

Principles of Data Visualization
Cleveland McGill Scale
Important Resources for Surveying the Data Visualization Options
Color Choices
Build a Cover Image Using Canva or InDesign or Powerpoint
Higher Resolution Graphics in Tableau

Basic Tableau

Downloading instructions for Tableau
Getting started tutorial with video
Building a basic COVID data chart with video and transcript
Using filters and calculations with video and transcript
Tutorial on Tableau calculations with video
Proper formatting of a filter bar in Tableau, video
Links to additional Tableau Tutorials

-Read our reader feedback on the new site. Draft a response to this person. We’ll discuss and then send one

See “Stacy Robinson Your Post on Twitter” in Files | Teams
https://bit.ly/32tw7Q1

Read Before Next Class

Chapter: Tableau https://bookdown.org/connect/#/apps/f79d74ff-4d33-4bfd-a1aa-de6aaf4e340a/access


Wednesday, Sept. 15: Tableau

Agenda

Tableau

Read Before Next Class

Chapter: Writing About Data https://bookdown.org/connect/#/apps/f79d74ff-4d33-4bfd-a1aa-de6aaf4e340a/access

Homework: See Blackboard, Friday Sept. 17


Monday, Sept. 20: Tableau, Writing About Data

Agenda

Basic Tableau

Downloading instructions for Tableau
Getting started tutorial with video
Building a basic COVID data chart with video and transcript
Using filters and calculations with video and transcript
Tutorial on Tableau calculations with video
Proper formatting of a filter bar in Tableau, video
Links to additional Tableau Tutorials

-For Wednesday

Chapter: Writing About Data https://bookdown.org/connect/#/apps/f79d74ff-4d33-4bfd-a1aa-de6aaf4e340a/access


Wednesday, Sept. 22

Agenda

Writing About Data

Writing About Data

Writing Style Notes
Common Errors – Math
AP Style with Numbers

Exercise: Peer Editing of Unedited Data Stories

Read Before Next Class

Chapter: Tableau Maps https://bookdown.org/connect/#/apps/f79d74ff-4d33-4bfd-a1aa-de6aaf4e340a/access


Monday Sept. 27: Tableau Maps

Agenda

Tableau - Maps

Mapping tutorial & sample dataset
Build a Map COVID-19 Positivity in Arkansas Counties
Video
Dual Mapping - Bubble Maps

Reminder: Assignment 2: Reporting Memo with Tableau Chart, Due Oct 3 Students gather, analyze and visualize Arkansascovid data and produce a Tableau chart suitable for publication. Data dictionary required. Report and write a 400 word story and provide social media.

Read Before Next Class

Chapter: Tableau Maps https://bookdown.org/connect/#/apps/f79d74ff-4d33-4bfd-a1aa-de6aaf4e340a/access


Wednesday Sept. 29: Tableau Maps

Agenda

Tableau Maps
Questions About Assignment 2, due Monday

Tableau - Maps

Mapping tutorial & sample dataset
Build a Map COVID-19 Positivity in Arkansas Counties
Video
Dual Mapping - Bubble Maps

Tableau - Maps

Mapping tutorial & sample dataset
Build a Map COVID-19 Positivity in Arkansas Counties
Video
Dual Mapping - Bubble Maps

Exercises

Read Before Next Class

Chapter: WordPress https://bookdown.org/connect/#/apps/f79d74ff-4d33-4bfd-a1aa-de6aaf4e340a/access


Monday Oct. 4: WordPress

WordPress

  Using WordPress
  Access back end
  Embedding interactive data 
  Embed Flourish in WordPress
  Embed Tableau in WordPress
  Building the Web Page

Agenda

Embed visualizations in WordPress

Assignment 2: Reporting Memo with Tableau Chart

Due Oct 3
Students gather, analyze and visualize Arkansascovid data and produce a Tableau chart suitable for publication. Data dictionary required. Report and write a 400 word story and provide social media.


Wednesday Oct. 6: WordPress

Agenda

WordPress

  Using WordPress
  Access back end
  Embedding interactive data 
  Embed Flourish in WordPress
  Embed Tableau in WordPress
  Building the Web Page    

Monday, Oct. 12: Flourish

Agenda

More Flourish

Videos to Get Started
Beginning Documents
Flourish Design Tips
More Resources
Adam Marton Cheat Sheet
Flourish newsrooms plan
Flourish - Stories
Examples from Fall Class
Basic Map
View and Read More Flourish Tutorials 


Flourish - Stories
https://www.youtube.com/watch?v=P7AmUdSBOVU
Bar chart race template
https://towardsdatascience.com/step-by-step-tutorial-create-a-bar-chart-race-animation-da7d5fcd7079
Content to popups
https://help.flourish.studio/article/69-how-to-add-custom-content-to-your-popups

Discuss Story #3: Interactive Map - Use This Form:

https://docs.google.com/forms/d/e/1FAIpQLScws1-wOhgQ7DV4MhGNoX8QbJFdX6LH91oY6NBv76GtRzTBTA/viewform
Assignment 3: Interactive Map.

  Due Oct 24 
  Students will build interactive maps of Arkansascovid data. 
  Results will be posted on GitHub. Data dictionary required. 
  Basic R used for analysis. Report and write a 400 word story.
  
  

Exercises

Watch Before Next Class

Alberto Cairo, Flourish Tutorials, Parts 1-6    
https://www.youtube.com/user/albertocairo1706/videos

Wednesday Oct. 13: Flourish - Map Story Pitches

Agenda

Flourish Workbook Updates    

More Flourish

Videos to Get Started
Beginning Documents
Flourish Design Tips
More Resources
Adam Marton Cheat Sheet
Flourish newsrooms plan
Flourish - Stories
Examples from Fall Class
Basic Map
Flourish Links

Homework: See Blackboard for Friday Oct 15


Monday Oct. 18: Introduction to R

Agenda
R Introduction Discuss Assignment 3 Interactive Map

Chapter: R_Intro
https://bookdown.org/connect/#/apps/f79d74ff-4d33-4bfd-a1aa-de6aaf4e340a/access

Introduction to R

  Install R and R Studio.
  Basic tutorial on R
  R1_Intro-to-R exercises
  Reading
  Reproducible research Repetitive tasks in modern newsrooms
  Popular R Libraries
  Data Types and R
  Reference: Logical Operators in R
  Packages
  Important Reference Materials
  R and R Studio     

Discuss Assignment 3: Interactive Map. Due Oct 24

Students will build interactive maps of Arkansascovid data. Results will be posted on GitHub.      Data dictionary required. Basic R used for analysis. Report and write a 400 word story.

Exercise

–Left click on the link below, remove .txt extension, save as all files 

https://github.com/profrobwells/CovidFall2020/blob/master/Exercises/Intro%20to%20R%208-20-2020.Rmd

Second option: If that isn’t successful, then go to the  https://raw.githubusercontent.com/profrobwells/CovidFall2020/master/Exercises/Intro%20to%20R%208-20-2020.Rmd –Left Click on document –Save as ALL FILES. REMOVE .TXT extension

Third option: Download "Intro to R 8_20_2020.rmd from your browser directly. https://github.com/profrobwells/CovidFall2020/tree/master/Exercises

Homework: Finish Tutorial R1_Intro-to-R exercises

Chapter: R Intro https://bookdown.org/connect/#/apps/f79d74ff-4d33-4bfd-a1aa-de6aaf4e340a/access


Wednesday, Oct. 20: Introduction to R

Agenda

Introduction to R

Key Points

 Reproducible research   
 Repetitive tasks in modern newsrooms.  Employment reports, crime stats, budgets
 Variables - an R object
 Assignment operator <-
 Case sensitive
 Vector: A vector can only have one type of data - all integers, all strings
 Dataframe - like a spreadsheet
 Save files - Don’t save workspace: because all of your variables will be 
 stored and re-loaded the next time you launch RStudio. 
 It’s too easy to forget about previously stored variables that can 
 interfere with later work

Software packages: tidyverse, rio, pacman

Exercises

Homework: Friday Oct. 22 Homework. –See Blackboard


Monday Oct 25: Basic R

Agenda

R Tables Exercises  

Assignment 3: Interactive Map

Due Oct 24 Students will build interactive maps of Arkansascovid data. Results will be posted on GitHub. Data dictionary required. Basic R used for analysis. Report and write a 400 word story.

Pipes - a Much-Used Command to Link Filters, Functions

    pipe %>%     CMD +  Shift + M  

  • **Dplyr Presentation*  

    Five basic verbs     filter()     select()     arrange()     mutate()     summarize()     plus group_by()

      Check what software packages are running: Global Environment       Navigation:      ^ + shift + 8 = Zoom to Environment       AP Style on numbers: AP Numerals Entry.pdf


Wednesday Oct 27: Tidyverse and R

Agenda

Tidyverse
Dplyr
Math with R    

    

Exercises

Homework: Friday, Oct 29 –See Blackboard


Monday, Nov. 1: Dates in R

Agenda

Lubridate
top_n 

Top_n

 List of Days of Most New Cases  

https://app.flourish.studio/visualisation/4007988/edit

 Data is topcases.csv 
 Values: Date, New Cases Today (column D) 
 --R table automatically selects the top 10. 
 --no filter  

Exercises

 Using Lubridate    
 Download:

https://github.com/profrobwells/CovidFall2020/blob/master/Exercises/Slicing-Dicing%20Data%2010-14-2020.Rmd

Homework: Tuesday, Nov. 2 Homework -See Blackboard


Monday, Nov. 8: Calculations in R

Agenda

Calculations in R   
Discuss Assignment 4

Assignment 4: Interactive Data Visualization. Due Nov 14. Students build multipanel interactive graphics / maps of Arkansascovid data by school district. Basic R used for analysis. Results will be posted on GitHub. Data dictionary required. Report and write a 600 word story.

Exercises

Using R to Shorten, Simplify the Master File https://github.com/profrobwells/CovidFall2020/blob/master/Exercises/Slicing-Dicing%20Data%2010-14-2020.Rmd

Red vs Blue Covid election results map   

https://apnews.com/article/counties-worst-virus-surges-voted-trump-d671a483534024b5486715da6edb6ebf


Wednesday, Nov. 10: R Data Visualization

Agenda

Graphics - ggplot     
Discuss Assignment #4
Quick Charts in Daily Script

  How We Did This: Daily Update Script

https://raw.githubusercontent.com/profrobwells/CovidFall2020/master/Daily%20Update.Rmd

R data visualization

  Basic GGPLOT
  Using color
  Formatting PNG for export
  Scatterplots
  Histograms
  Box plots
  Line graphs
  ggplot cookbook 4-26-20.rmd

We will build this today

GGPLOT Cookbook

https://raw.githubusercontent.com/profrobwells/CovidFall2020/master/Exercises/ggplot%20cookbook%204-26-20.Rmd

New Fun with Sicing and Dicing
https://github.com/profrobwells/CovidFall2020/blob/master/Exercises/Slicing-Dicing%20Data%2010-14-2020.Rmd


Monday, Nov. 15: R Graphics

Agenda

Graphics  
Red vs Blue Covid election results map    

Assignment 4: Interactive Data Visualization

Due Nov 14.
Students build multipanel interactive graphics / maps of Arkansascovid data by school district.     Basic R used for analysis. Results will be posted on GitHub. Data dictionary required. Report      and write a 600 word story.

Exercises

We will build this today

GGPLOT Cookbook

https://raw.githubusercontent.com/profrobwells/CovidFall2020/master/Exercises/ggplot%20cookbook%204-26-20.Rmd

New Fun with Sicing and Dicing
https://github.com/profrobwells/CovidFall2020/blob/master/Exercises/Slicing-Dicing%20Data%2010-14-2020.Rmd


Wednesday, Nov. 17

Agenda

 GGPLOT
 Feeding R to Flourish

Exercise

Katy’s Chart

https://app.flourish.studio/visualisation/4380046/edit

Tutorial

Details on Line Chart Race

https://help.flourish.studio/article/75-line-chart-race-an-overview

Details of a Bar Chart Race

https://help.flourish.studio/article/44-bar-chart-race-an-overview

Attempt at a Bar Chart Race by County on New Deaths
--Formatting Data to Match Flourish Requirements.
--Pivot Table

https://app.flourish.studio/visualisation/4379103/edit

Your Turn:

Build Cases Per 10,000
Build Demographics Over Time
Build Counties Over Time    

Read Before Next Class


Nov. 22-26: Thanksgiving Week, Holiday


Monday, Nov. 30: Reporting

Agenda

Discuss Assignment 5
Datawrapper

Assignment 5: Multimedia Data Story. Due Dec 5. Students will produce a blog post with photos, a short video, a map and an interactive graphic plus a 400 word story. Basic R used for analysis. Results will be posted on GitHub. Data dictionary required.

Datawrapper

https://app.datawrapper.de/

Exercises

Create Monthly Totals for November

Create a New R Markdown File for November Totals   
Use this Slicing and Dicing Exercise as a Template  
Monthly Totals for Hospitals, Deaths, New Cases  
Visualize in Flourish  
Post your code on Teams 

https://github.com/profrobwells/CovidFall2020/blob/master/Exercises/Slicing-Dicing%20Data%2010-14-2020.Rmd

Homework: Tuesday, Nov. 30. –See Blackboard


Wednesday, Dec. 1: Assignment 5

Agenda

Workshop on Assignment 5

Monday, Dec. 6: Wrapup

Agenda

Datawrapper
 

Assignment 5: Multimedia Data Story

Due Dec 5. Students will produce a blog post with photos, a short video, a map and an interactive graphic plus a 400 word story. Basic R used for analysis. Results will be posted on GitHub. Data dictionary required.

Important!

Course Evaluation
Please do me  a favor and evaluate this course. 
It's important to me and the department to get your thoughts
on what worked and what did not. 
If you think it is important, 
then please take five minutes to fill out the survey.

https://courseval.uark.edu/

Exercises: Basic GitHub

This class is intended to teach you modern workflow techniques for coding. A centerpiece of that workflow is GitHub. This is a website with a system that allows you to collaborate with other programmers on coding projects. It manages versions of software code and is a very popular with the tech elite. 

Your GitHub account, which is public, represents an important professional image. Prospective employers and collaborators will look at your GitHub account.

Create a GitHub account   

https://github.com/

Exercise #1: Hello World Setup

https://guides.github.com/activities/hello-world/

Exercise #2: GitHub flow

https://guides.github.com/introduction/flow/

Help Files

https://help.github.com/en/desktop

Exercise #3: Pull Request
https://docs.google.com/presentation/d/1MbltRcOerktc-E26HMDjYj0BO9CTubQWu1Z2bB9CpVY/edit#slide=id.g448ccc227721fe56_10

  See the above link, Max Harlow on How to Use GitHub   
  1. Create a test repository, call it "Junk"
  2. Commit copies of a random R script and a random text .txt file
  3. Pair up with a buddy. Follow them on GitHub
  4. Fork their Junk repository
  5. Report an Issue on their repository. See slides #47-53
  6. Create a pull request on their repository. See slides #54-68
  7. Resolve the issues and pull request for your own GitHub account.
  8. Revel in your nerd powers. Watch Star Trek reruns. Eat Pringles.
  

GitHub Resources

Basic GitHub 4-22-19.R
https://bit.ly/2UAMGTd

Another GitHub guide
https://andrewbtran.github.io/NICAR/2018/workflow/docs/03-integrating_github.html

Simplified GitHub- GitHub Desktop
https://help.github.com/en/desktop

Setting up an R Workflow
http://learn.r-journalism.com/en/publishing/workflow/r-projects/

Advanced: Set Up GitHub in an R Project https://support.rstudio.com/hc/en-us/articles/200532077?version=1.2.5033&mode=desktop


Wednesday, Dec. 8

Agenda

  GitHub   
  Wrap up       
  

Congratulations!

 We covered a lot this semester

–30–